Release 10.1A: OpenEdge Development:
Programming Interfaces

Disconnecting databases

By default, OpenEdge disconnects all databases at the end of a session. You can explicitly disconnect a database with the DISCONNECT statement, which has the following syntax:

Syntax

DISCONNECT logical-database-name

The logical–database–name represents the logical name of a connected database. It can be an unquoted string, a quoted string, or a character expression.

A DISCONNECT statement does not execute until all active procedures that reference the database end or stop:

i-mainprc1.p

CONNECT -db mydb -1. RUN i-subproc1.p.

i-subproc1.p

RUN i-subproc2.p. FOR EACH mydb.customer FIELDS (name address city state postal-code):   UPDATE name address city state postal-code. END.

i-subproc2.p

DISCONNECT mydb.

In these procedures, the mydb database is not disconnected until the end of the i-subproc1.p procedure.